package com.acwer.dao.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;


@Repository
public interface MiniPfmMapper  {

    @Select({
            "<script>",
            "select top 100 * from N041 where upload=0",
            "</script>"
    })
    public List<Map<String,Object>> select();

    @Select({
            "<script>",
            "update N041 set upload=1 where id in",
            "<foreach collection='list' open='(' close=')' item='id' index='i' separator=','>",
            "#{id}",
            "</foreach>",
            "</script>"
    })
    public void updateById(@Param("list") List<String> list);
}
